package com.example.shoppingmall.dao;

import com.example.shoppingmall.pojo.Picture;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface PictureMapper {

    //多条件模糊查询+分页
    public List<Picture> picList(@Param("pic_ID") Integer pic_ID, @Param("pic_name") String pic_name,
                                 @Param("pageNo") Integer pageNo, @Param("pageNum") Integer pageNum);

    //查询总条数
    public int total(@Param("pic_ID") Integer pic_ID, @Param("pic_name") String pic_name);

    //修改
    public int update(Picture picture);

    //根据用户的头像新增图片
    public int add(Picture picture);

}
